//
// Copyright (c) 2010
// by Will Morgenweck & Chris Paterra
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions 
// of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED 
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL 
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF 
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
// DEALINGS IN THE SOFTWARE.
//

using MbUnit.Framework;

namespace DotNetNuke.DNNQA.Tests
{
    [TestFixture(Order = 1)]
    public class SqlDataProviderFixturePreTest
    {
        [Test]
        public void ShouldGetValidSourceFolderPath()
        {
            Assert.IsTrue(System.IO.Directory.Exists(DatabaseEnvironment.SourceDatabaseFolderPath));
        }

        [Test]
        public void ShouldNotHaveParentReferenceInSourceFolderPath()
        {
            Assert.DoesNotContain(DatabaseEnvironment.SourceDatabaseFolderPath, "..");
        }

        [Test]
        public void ShouldReadTestDatabaseSetupScript()
        {
            // Arrange
            var scriptPath = System.IO.Path.Combine(DatabaseEnvironment.SourceDatabaseFolderPath, DatabaseEnvironment.TestDatabaseSetupScript);
            // Act
            var scriptText = System.IO.File.ReadAllText(scriptPath);
            // Assert
            Assert.IsFalse(string.IsNullOrEmpty(scriptText));
        }

        [Test]
        public void ShouldReadModuleUnInstallScript()
        {
            // Arrange
            var scriptPath = System.IO.Path.Combine(DatabaseEnvironment.SourceDatabaseFolderPath, DatabaseEnvironment.ModuleUnInstallScript);
            // Act
            var scriptText = System.IO.File.ReadAllText(scriptPath);
            // Assert
            Assert.IsFalse(string.IsNullOrEmpty(scriptText));
        }

        [Test]
        public void ShouldReadModuleInstallScripts()
        {
            // Arrange

        	foreach (var fileName in DatabaseEnvironment.ModuleInstallScripts)
            {
                // Act
                var scriptPath = System.IO.Path.Combine(DatabaseEnvironment.SourceDatabaseFolderPath, fileName);
                var scriptText = System.IO.File.ReadAllText(scriptPath);
                // Assert
                Assert.IsFalse(string.IsNullOrEmpty(scriptText));
            }
        }
    }
}
